package com.itheima.ydd.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.itheima.ydd.dto.Advposnums;
import com.itheima.ydd.entity.Advimg;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Mapper接口
 */
@Mapper
public interface AdvimgMapper extends BaseMapper<Advimg> {
    @Select("SELECT advimgpos,COUNT(*) AS advposnum FROM ydd_advimg group by advimgpos;")
    List<Advposnums> getAdvposnums();
}
